Querying AWS Athena using a Lambda Function

Athena

An AWS service that enables data analysts to perform interactive queries in the web-based cloud storage service, S3. It is usually used with large-scale data sets. It enables users to analyze data in Amazon S3 using SQL. It is mostly for quick, ad hoc, and complex analysis. A serverless service where underlying compute infrastructure need not be handled for the users.

AWS Lambda

A serverless compute service which runs code as a reply to events and automatically takes care of the bottom resources. It runs code on high availability compute infrastructure and performs all the administration of the compute resources. A few examples are HTTP requests vis Amazon API Gateway, changes to objects in S3, and many others.

Follow the below article to connect with s3 and how to query S3 files using Athena

Demo

First creating an execution role that will be used in the lambda function creating a lambda function Now increase the timeout so that lambda gets enough time to query Now move into the code section as shown below and make changes to the code Give the respective query you want to query, database name and output location i.e S3 bucket as specified in the above Athena article Now clicking deploy and testing the code